package com.bioroadlab.updatedata;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class UpdateDataFromLink {
	
	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn = (Connection) DriverManager.getConnection(
					"jdbc:mysql:///diseaseoflinkcapture111", "root",
					"root");
			Statement stat = (Statement) conn.createStatement();
			String sql = "select * from t_diseaselink";
			
			ResultSet rs = stat.executeQuery(sql);
			
			
			System.out.println(rs.getRow());
			
			rs.close();
			stat.close();
			conn.close();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}

}
